USE Secure
GO

CREATE TRIGGER trgThankYou ON DATABASE FOR CREATE_TABLE
AS PRINT 'Thank you for your contribution!'

--

CREATE TABLE NewTable (ID int)

--

CREATE TRIGGER trgSafety ON DATABASE FOR DROP_TABLE
AS ROLLBACK PRINT 'Sorry, you may not drop tables!'

--

DROP TABLE NewTable

-- How do you drop DDL triggers? (Have SMS show you ...)

DROP TRIGGER [trgSafety] ON DATABASE
DROP TRIGGER [trgThankYou] ON DATABASE
DROP TABLE NewTable
